﻿CREATE PROCEDURE Update_DataTypeTable
	@IntField int,
	@IntEnumField int,
	@NVarCharEnumField nvarchar(100),
	@BitField bit,
	@DateTimeField datetime,
	@DecimalField decimal(18   ,6    ),
	@FloatField float,
	@MoneyField money,
	@NTextField ntext,
	@NVarCharField nvarchar(100),
	@RealField real,
	@GuidField uniqueidentifier,
	@ImageField image,
	@VarBinaryField varbinary(50),
	@TableId int
AS
UPDATE [DataTypeTable]
SET
	[IntField] = @IntField,
	[IntEnumField] = @IntEnumField,
	[NVarCharEnumField] = @NVarCharEnumField,
	[BitField] = @BitField,
	[DateTimeField] = @DateTimeField,
	[DecimalField] = @DecimalField,
	[FloatField] = @FloatField,
	[MoneyField] = @MoneyField,
	[NTextField] = @NTextField,
	[NVarCharField] = @NVarCharField,
	[RealField] = @RealField,
	[GuidField] = @GuidField,
	[ImageField] = @ImageField,
	[VarBinaryField] = @VarBinaryField
WHERE
	[TableId] = @TableId


